DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	323881
Missing cells	49706
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.6 MiB
Average record size in memory	112.0 B

Variable types

Categorical	3
DateTime	1
Numeric	9
Text	1

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 49706 (15.3%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.00580727)	Skewed

Reproduction

Analysis started	2023-05-24 08:19:25.412602
Analysis finished	2023-05-24 08:19:48.074046
Duration	22.66 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

1.0	323881

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	971643
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	323881	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	323881	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	323881	33.3%
.	323881	33.3%
0	323881	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	647762	66.7%
Other Punctuation	323881	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	323881	50.0%
0	323881	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	323881	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	971643	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	323881	33.3%
.	323881	33.3%
0	323881	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	971643	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	323881	33.3%
.	323881	33.3%
0	323881	33.3%

DATUM_BESTAND
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

2023-05-10	323881

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3238810
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-05-10
2nd row	2023-05-10
3rd row	2023-05-10
4th row	2023-05-10
5th row	2023-05-10

Common Values

Value	Count	Frequency (%)
2023-05-10	323881	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-05-10	323881	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2591048	80.0%
Dash Punctuation	647762	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	971643	37.5%
2	647762	25.0%
3	323881	12.5%
5	323881	12.5%
1	323881	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	647762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3238810	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3238810	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

PEILDATUM
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

2023-05-01	323881

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3238810
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-05-01
2nd row	2023-05-01
3rd row	2023-05-01
4th row	2023-05-01
5th row	2023-05-01

Common Values

Value	Count	Frequency (%)
2023-05-01	323881	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-05-01	323881	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2591048	80.0%
Dash Punctuation	647762	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	971643	37.5%
2	647762	25.0%
3	323881	12.5%
5	323881	12.5%
1	323881	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	647762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3238810	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3238810	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	971643	30.0%
2	647762	20.0%
-	647762	20.0%
3	323881	10.0%
5	323881	10.0%
1	323881	10.0%

JAAR
Date

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

Minimum	2012-01-01 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	442.96919

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	361
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	1008.0077
Coefficient of variation (CV)	2.2755707
Kurtosis	58.499913
Mean	442.96919
Median Absolute Deviation (MAD)	8
Skewness	7.7729381
Sum	1.434693 × 10⁸
Variance	1016079.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	45708	14.1%
313	41933	12.9%
303	37351	11.5%
330	25543	7.9%
316	22002	6.8%
308	17494	5.4%
306	13567	4.2%
324	13306	4.1%
301	12905	4.0%
304	10483	3.2%
Other values (18)	83589	25.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	12905	4.0%
302	7088	2.2%
303	37351	11.5%
304	10483	3.2%
305	45708	14.1%
306	13567	4.2%
307	5674	1.8%
308	17494	5.4%
310	3569	1.1%
313	41933	12.9%

Value	Count	Frequency (%)
8418	4488	1.4%
8416	596	0.2%
1900	213	0.1%
390	869	0.3%
389	3430	1.1%
362	4339	1.3%
361	2347	0.7%
335	3261	1.0%
330	25543	7.9%
329	837	0.3%

TYPERENDE_DIAGNOSE_CD
Text

Distinct	1899
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

Length

Max length	4
Median length	3
Mean length	3.3522528
Min length	2

Characters and Unicode

Total characters	1085731
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	14
2nd row	03
3rd row	17
4th row	01
5th row	12

Value	Count	Frequency (%)
101	1384	0.4%
402	1325	0.4%
403	1302	0.4%
301	1302	0.4%
201	1226	0.4%
203	1226	0.4%
401	1091	0.3%
404	1077	0.3%
802	1051	0.3%
409	1046	0.3%
Other values (1889)	311851	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	207822	19.1%
0	199075	18.3%
2	143985	13.3%
3	117583	10.8%
5	83783	7.7%
9	78106	7.2%
4	76968	7.1%
7	63960	5.9%
6	56719	5.2%
8	46752	4.3%
Other values (15)	10978	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1074753	99.0%
Uppercase Letter	10978	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2055	18.7%
M	1851	16.9%
B	1320	12.0%
E	924	8.4%
Z	924	8.4%
D	732	6.7%
A	708	6.4%
F	685	6.2%
C	364	3.3%
K	352	3.2%
Other values (5)	1063	9.7%

Decimal Number

Value	Count	Frequency (%)
1	207822	19.3%
0	199075	18.5%
2	143985	13.4%
3	117583	10.9%
5	83783	7.8%
9	78106	7.3%
4	76968	7.2%
7	63960	6.0%
6	56719	5.3%
8	46752	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1074753	99.0%
Latin	10978	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2055	18.7%
M	1851	16.9%
B	1320	12.0%
E	924	8.4%
Z	924	8.4%
D	732	6.7%
A	708	6.4%
F	685	6.2%
C	364	3.3%
K	352	3.2%
Other values (5)	1063	9.7%

Common

Value	Count	Frequency (%)
1	207822	19.3%
0	199075	18.5%
2	143985	13.4%
3	117583	10.9%
5	83783	7.8%
9	78106	7.3%
4	76968	7.2%
7	63960	6.0%
6	56719	5.3%
8	46752	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1085731	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	207822	19.1%
0	199075	18.3%
2	143985	13.3%
3	117583	10.8%
5	83783	7.7%
9	78106	7.2%
4	76968	7.1%
7	63960	5.9%
6	56719	5.2%
8	46752	4.3%
Other values (15)	10978	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6065
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4256934 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999040
Q1	99899018
median	1.49899 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051605 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9010499 × 10⁸

Descriptive statistics

Standard deviation	4.293743 × 10⁸
Coefficient of variation (CV)	0.97018537
Kurtosis	-1.7454639
Mean	4.4256934 × 10⁸
Median Absolute Deviation (MAD)	1.2 × 10⁸
Skewness	0.4591178
Sum	1.433398 × 10¹⁴
Variance	1.8436229 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2325	0.7%
990004007	2294	0.7%
990003004	2269	0.7%
990004006	1882	0.6%
990356076	1692	0.5%
990356073	1575	0.5%
131999228	1499	0.5%
131999164	1483	0.5%
990003007	1471	0.5%
131999194	1361	0.4%
Other values (6055)	306030	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	11	< 0.1%
10501004	12	< 0.1%
10501005	11	< 0.1%
10501007	3	< 0.1%
10501008	12	< 0.1%
10501010	12	< 0.1%
10501011	3	< 0.1%
11101002	10	< 0.1%
11101003	12	< 0.1%

Value	Count	Frequency (%)
998418081	162	0.1%
998418080	147	< 0.1%
998418079	38	< 0.1%
998418077	8	< 0.1%
998418076	9	< 0.1%
998418075	7	< 0.1%
998418074	215	0.1%
998418073	216	0.1%
998418072	8	< 0.1%
998418071	8	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10272
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	527.24646

Minimum	1
Maximum	165128
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	105
95-th percentile	1795
Maximum	165128
Range	165127
Interquartile range (IQR)	102

Descriptive statistics

Standard deviation	3237.2011
Coefficient of variation (CV)	6.1398252
Kurtosis	393.85328
Mean	527.24646
Median Absolute Deviation (MAD)	13
Skewness	16.45387
Sum	1.7076511 × 10⁸
Variance	10479471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	53452	16.5%
2	26088	8.1%
3	17054	5.3%
4	12435	3.8%
5	9745	3.0%
6	8283	2.6%
7	6852	2.1%
8	5768	1.8%
9	5274	1.6%
10	4704	1.5%
Other values (10262)	174226	53.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	53452	16.5%
2	26088	8.1%
3	17054	5.3%
4	12435	3.8%
5	9745	3.0%
6	8283	2.6%
7	6852	2.1%
8	5768	1.8%
9	5274	1.6%
10	4704	1.5%

Value	Count	Frequency (%)
165128	1	< 0.1%
162302	1	< 0.1%
155873	1	< 0.1%
154260	1	< 0.1%
154256	1	< 0.1%
144717	1	< 0.1%
134885	1	< 0.1%
118397	1	< 0.1%
115938	1	< 0.1%
113442	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	11021
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	624.25997

Minimum	1
Maximum	240002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	115
95-th percentile	2045
Maximum	240002
Range	240001
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	4170.5373
Coefficient of variation (CV)	6.68077
Kurtosis	700.23426
Mean	624.25997
Median Absolute Deviation (MAD)	14
Skewness	21.005807
Sum	2.0218594 × 10⁸
Variance	17393381
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	51417	15.9%
2	25637	7.9%
3	16888	5.2%
4	12243	3.8%
5	9663	3.0%
6	8236	2.5%
7	6825	2.1%
8	5712	1.8%
9	5179	1.6%
10	4738	1.5%
Other values (11011)	177343	54.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	51417	15.9%
2	25637	7.9%
3	16888	5.2%
4	12243	3.8%
5	9663	3.0%
6	8236	2.5%
7	6825	2.1%
8	5712	1.8%
9	5179	1.6%
10	4738	1.5%

Value	Count	Frequency (%)
240002	1	< 0.1%
232423	1	< 0.1%
231954	1	< 0.1%
230966	1	< 0.1%
227936	1	< 0.1%
227409	1	< 0.1%
226314	1	< 0.1%
223905	1	< 0.1%
218673	1	< 0.1%
215053	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	9144
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7909.6674

Minimum	1
Maximum	230248
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	40
Q1	416
median	1780
Q3	6622
95-th percentile	37704
Maximum	230248
Range	230247
Interquartile range (IQR)	6206

Descriptive statistics

Standard deviation	18196.621
Coefficient of variation (CV)	2.3005546
Kurtosis	33.20745
Mean	7909.6674
Median Absolute Deviation (MAD)	1622
Skewness	4.9954146
Sum	2.561791 × 10⁹
Variance	3.3111703 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	570	0.2%
2	536	0.2%
21	513	0.2%
17	493	0.2%
25	485	0.1%
8	475	0.1%
9	473	0.1%
3	472	0.1%
19	462	0.1%
5	461	0.1%
Other values (9134)	318941	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	570	0.2%
2	536	0.2%
3	472	0.1%
4	457	0.1%
5	461	0.1%
6	458	0.1%
7	416	0.1%
8	475	0.1%
9	473	0.1%
10	360	0.1%

Value	Count	Frequency (%)
230248	23	< 0.1%
227944	23	< 0.1%
217927	24	< 0.1%
214511	17	< 0.1%
213519	25	< 0.1%
211593	17	< 0.1%
210419	19	< 0.1%
207311	19	< 0.1%
205347	17	< 0.1%
200603	16	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	10213
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11446.022

Minimum	1
Maximum	369972
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	1
5-th percentile	52
Q1	556
median	2478
Q3	9449
95-th percentile	53662
Maximum	369972
Range	369971
Interquartile range (IQR)	8893

Descriptive statistics

Standard deviation	27198.52
Coefficient of variation (CV)	2.3762422
Kurtosis	36.482962
Mean	11446.022
Median Absolute Deviation (MAD)	2275
Skewness	5.2273769
Sum	3.7071489 × 10⁹
Variance	7.3975947 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	478	0.1%
2	438	0.1%
3	408	0.1%
6	397	0.1%
25	383	0.1%
5	369	0.1%
17	366	0.1%
4	366	0.1%
20	360	0.1%
19	354	0.1%
Other values (10203)	319962	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	478	0.1%
2	438	0.1%
3	408	0.1%
4	366	0.1%
5	369	0.1%
6	397	0.1%
7	352	0.1%
8	306	0.1%
9	283	0.1%
10	332	0.1%

Value	Count	Frequency (%)
369972	23	< 0.1%
364718	23	< 0.1%
348488	25	< 0.1%
343256	24	< 0.1%
341656	19	< 0.1%
323759	20	< 0.1%
315781	17	< 0.1%
310778	17	< 0.1%
298646	17	< 0.1%
294837	16	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	322
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	689067.34

Minimum	3
Maximum	1487638
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	3
5-th percentile	42576
Q1	297916
median	765029
Q3	1032670
95-th percentile	1340700
Maximum	1487638
Range	1487635
Interquartile range (IQR)	734754

Descriptive statistics

Standard deviation	411993.89
Coefficient of variation (CV)	0.59790077
Kurtosis	-1.0915012
Mean	689067.34
Median Absolute Deviation (MAD)	315911
Skewness	-0.085927311
Sum	2.2317582 × 10¹¹
Variance	1.6973897 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880937	5102	1.6%
874100	4354	1.3%
843977	4347	1.3%
894319	4333	1.3%
880479	4273	1.3%
897711	4212	1.3%
765029	4089	1.3%
802826	4026	1.2%
1080940	3890	1.2%
1100054	3866	1.2%
Other values (312)	281389	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	4	< 0.1%
6	2	< 0.1%
9	7	< 0.1%
16	3	< 0.1%
29	12	< 0.1%
33	9	< 0.1%
96	19	< 0.1%
116	28	< 0.1%
142	42	< 0.1%
151	1	< 0.1%

Value	Count	Frequency (%)
1487638	2975	0.9%
1450399	3048	0.9%
1421728	3564	1.1%
1344384	3543	1.1%
1340700	3441	1.1%
1332379	3545	1.1%
1316489	3463	1.1%
1282947	3576	1.1%
1267063	3352	1.0%
1265243	1177	0.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	322
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1116593.1

Minimum	3
Maximum	2664930
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	3
5-th percentile	46431
Q1	515740
median	1129339
Q3	1810699
95-th percentile	2548762
Maximum	2664930
Range	2664927
Interquartile range (IQR)	1294959

Descriptive statistics

Standard deviation	738999.28
Coefficient of variation (CV)	0.66183398
Kurtosis	-0.81055633
Mean	1116593.1
Median Absolute Deviation (MAD)	632720
Skewness	0.29566631
Sum	3.616433 × 10¹¹
Variance	5.4611994 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211795	5102	1.6%
1281499	4354	1.3%
1216255	4347	1.3%
1315581	4333	1.3%
1300441	4273	1.3%
1341849	4212	1.3%
1155949	4089	1.3%
1203644	4026	1.2%
2548762	3890	1.2%
2664930	3866	1.2%
Other values (312)	281389	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	4	< 0.1%
6	2	< 0.1%
9	7	< 0.1%
16	3	< 0.1%
31	12	< 0.1%
35	9	< 0.1%
96	19	< 0.1%
129	28	< 0.1%
147	42	< 0.1%
154	1	< 0.1%

Value	Count	Frequency (%)
2664930	3866	1.2%
2663352	3797	1.2%
2619520	3789	1.2%
2594184	3844	1.2%
2548762	3890	1.2%
2480464	3851	1.2%
2178864	3757	1.2%
2111895	3732	1.2%
2062429	3811	1.2%
2052309	1168	0.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

Distinct	3560
Distinct (%)	1.3%
Missing	49706
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	3605.7417

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.5 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	480
median	1270
Q3	4205
95-th percentile	13710
Maximum	287220
Range	287150
Interquartile range (IQR)	3725

Descriptive statistics

Standard deviation	6555.1533
Coefficient of variation (CV)	1.8179764
Kurtosis	143.03878
Mean	3605.7417
Median Absolute Deviation (MAD)	1035
Skewness	7.1204426
Sum	9.8860424 × 10⁸
Variance	42970034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2024	0.6%
105	1941	0.6%
110	1790	0.6%
180	1575	0.5%
185	1547	0.5%
300	1418	0.4%
145	1390	0.4%
175	1371	0.4%
120	1336	0.4%
165	1281	0.4%
Other values (3550)	258502	79.8%
(Missing)	49706	15.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	668	0.2%
95	716	0.2%
100	925	0.3%
105	1941	0.6%
110	1790	0.6%
115	1096	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
96945	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.218	0.007	0.013	-0.062	-0.056	-0.567	-0.477	0.050
ZORGPRODUCT_CD	0.218	1.000	-0.141	-0.150	-0.178	-0.211	-0.387	-0.418	0.029
AANTAL_PAT_PER_ZPD	0.007	-0.141	1.000	0.996	0.325	0.324	0.075	0.083	-0.305
AANTAL_SUBTRAJECT_PER_ZPD	0.013	-0.150	0.996	1.000	0.322	0.324	0.077	0.090	-0.307
AANTAL_PAT_PER_DIAG	-0.062	-0.178	0.325	0.322	1.000	0.988	0.319	0.298	0.023
AANTAL_SUBTRAJECT_PER_DIAG	-0.056	-0.211	0.324	0.324	0.988	1.000	0.331	0.328	0.032
AANTAL_PAT_PER_SPC	-0.567	-0.387	0.075	0.077	0.319	0.331	1.000	0.958	-0.015
AANTAL_SUBTRAJECT_PER_SPC	-0.477	-0.418	0.083	0.090	0.298	0.328	0.958	1.000	-0.017
GEMIDDELDE_VERKOOPPRIJS	0.050	0.029	-0.305	-0.307	0.023	0.032	-0.015	-0.017	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-05-10	2023-05-01	2018-01-01	329	14	990029010	4	4	97	97	21981	24168	1345.0
1	1.0	2023-05-10	2023-05-01	2018-01-01	329	03	990029011	375	379	847	863	21981	24168	545.0
2	1.0	2023-05-10	2023-05-01	2018-01-01	329	17	990029010	73	73	695	704	21981	24168	1345.0
3	1.0	2023-05-10	2023-05-01	2018-01-01	329	01	990029010	53	54	331	348	21981	24168	1345.0
4	1.0	2023-05-10	2023-05-01	2018-01-01	329	12	990029010	14	16	114	120	21981	24168	1345.0
5	1.0	2023-05-10	2023-05-01	2018-01-01	329	20	990029010	2	2	4	4	21981	24168	1345.0
6	1.0	2023-05-10	2023-05-01	2018-01-01	329	20	990029011	2	2	4	4	21981	24168	545.0
7	1.0	2023-05-10	2023-05-01	2018-01-01	329	05	990029002	120	124	1285	1346	21981	24168	205.0
8	1.0	2023-05-10	2023-05-01	2018-01-01	329	16	990029002	161	176	1077	1196	21981	24168	205.0
9	1.0	2023-05-10	2023-05-01	2018-01-01	329	99	990029011	141	141	3708	3848	21981	24168	545.0

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
323871	1.0	2023-05-10	2023-05-01	2022-01-01	306	091	149899017	4	4	196	263	469404	698999	970.0
323872	1.0	2023-05-10	2023-05-01	2012-01-01	303	216	199299070	4	4	5022	5325	1487638	1939509	3860.0
323873	1.0	2023-05-10	2023-05-01	2022-01-01	306	025	20110013	2	2	36	51	469404	698999	5490.0
323874	1.0	2023-05-10	2023-05-01	2012-01-01	303	410	192001062	1	1	690	797	1487638	1939509	NaN
323875	1.0	2023-05-10	2023-05-01	2014-01-01	313	452	131999145	1	1	455	572	1037388	2062429	4455.0
323876	1.0	2023-05-10	2023-05-01	2015-01-01	301	809	79899002	1	1	2891	3466	1084427	1653307	3410.0
323877	1.0	2023-05-10	2023-05-01	2012-01-01	303	134	131999131	1	1	5544	6593	1487638	1939509	5650.0
323878	1.0	2023-05-10	2023-05-01	2012-01-01	303	258	199299088	3	3	2284	2527	1487638	1939509	7575.0
323879	1.0	2023-05-10	2023-05-01	2015-01-01	301	103	79899014	1	1	55332	58003	1084427	1653307	90.0
323880	1.0	2023-05-10	2023-05-01	2014-01-01	313	431	972802118	1	1	12604	13877	1037388	2062429	7660.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample